How to: Delete a table.
Solution:
Select the table in the Database window, and select either 'Delete' or 'Cut' from the 'Edit' menu.
NOTE: A table cannot be deleted if it is related to any other tables. The relationships must be deleted in the Relationships window before the table can be deleted.
1) Make sure the table to delete is closed.
2) If the Database window is not active, activate the Database window.
3) Click the 'Tables' tab in the Database window.
Tables tab
4) Select the table to delete from the list. (The table name is highlighted.)
5) Select the 'Edit' menu and select 'Delete'. (A message appears confirming the deletion.)
Delete message
6) Click 'Yes' to delete the table. (If there are no relationships for the table, the table is deleted. If there are relationships for the table, a message appears saying all relationships to other table must be deleted first.)
7) If there are relationships for the table, click 'Yes' to delete relationships to other tables and to delete the table. (The relationships and the table are deleted.)
NOTE 1: Click 'No' at any message dialog box, to cancel the deletion of the selected table.
NOTE 2: To undelete a table just deleted, select the 'Edit' menu and select 'Undo Delete' or 'Undo Cut'.
